--StepTime Prc
delete from AUTOSC.MON_AVG_STEP_TIME where METRIC_NAME = 'Step Time to Process TaskType PRC';
delete from AUTOSC.CFG_METRICS where METRIC_NAME = 'Step Time to Process TaskType PRC';

INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
    to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'Step Time to Process TaskType PRC', 5, 'F');

INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
     to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'Step Time to Process TaskType PRC', 60, 'F');
	
INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
     to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'Step Time to Process TaskType PRC', 1440, 'F');

COMMIT;

--StepTime Prc
delete from AUTOSC.MON_AVG_STEP_TIME where METRIC_NAME = 'Step Time Avg Process';
delete from AUTOSC.CFG_METRICS where METRIC_NAME = 'Step Time Avg Process';

INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
    to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'Step Time Avg Process', 5, 'F');

INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
     to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'Step Time Avg Process', 60, 'F');
	
INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
     to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'Step Time Avg Process', 1440, 'F');

COMMIT;
--StepTime NonPrc
delete from AUTOSC.MON_AVG_STEP_TIME where METRIC_NAME = 'Step Time Avg NonProcess';
delete from AUTOSC.CFG_METRICS where METRIC_NAME = 'Step Time Avg NonProcess';

INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
    to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'Step Time Avg NonProcess', 5, 'F');

INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
     to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'Step Time Avg NonProcess', 60, 'F');
	
INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
     to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'Step Time Avg NonProcess', 1440, 'F');

COMMIT;


--P/F Count Task
delete from AUTOSC.MON_PASS_FAIL where METRIC_NAME = 'P/F Count Task';
delete from AUTOSC.CFG_METRICS where METRIC_NAME = 'P/F Count Task';

INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
    to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'P/F Count Task', 5, 'F');

INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
     to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'P/F Count Task', 60, 'F');
	
INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
     to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'P/F Count Task', 1440, 'F');

COMMIT;


--P/F Count Request
delete from AUTOSC.MON_PASS_FAIL where METRIC_NAME = 'P/F Count Request';
delete from AUTOSC.CFG_METRICS where METRIC_NAME = 'P/F Count Request';

INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
    to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'P/F Count Request', 5, 'F');

INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
     to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'P/F Count Request', 60, 'F');
	
INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
     to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'P/F Count Request', 1440, 'F');

COMMIT;

--P/F Count Request Type
delete from AUTOSC.MON_PASS_FAIL where METRIC_NAME = 'P/F Count Request Type';
delete from AUTOSC.CFG_METRICS where METRIC_NAME = 'P/F Count Request Type';

INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
    to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'P/F Count Request Type', 5, 'F');

INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
     to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'P/F Count Request Type', 60, 'F');
	
INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
     to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'P/F Count Request Type', 1440, 'F');

COMMIT;

--P/F Count Task Type
delete from AUTOSC.MON_PASS_FAIL where METRIC_NAME = 'P/F Count Task Type';
delete from AUTOSC.CFG_METRICS where METRIC_NAME = 'P/F Count Task Type';

INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
    to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'P/F Count Task Type', 5, 'F');

INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
     to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'P/F Count Task Type', 60, 'F');
	
INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
     to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'P/F Count Task Type', 1440, 'F');

COMMIT;


--Average time to process Task by Type
delete from AUTOSC.MON_AVG_STEP_TIME where METRIC_NAME = 'Average time to process Task by Type';
delete from AUTOSC.CFG_METRICS where METRIC_NAME = 'Average time to process Task by Type';

INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
    to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'Average time to process Task by Type', 5, 'F');

INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
     to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'Average time to process Task by Type', 60, 'F');
	
INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
     to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'Average time to process Task by Type', 1440, 'F');

COMMIT;

--Average time to process Request by Type
delete from AUTOSC.MON_AVG_STEP_TIME where METRIC_NAME = 'Average time to process Request by Type';
delete from AUTOSC.CFG_METRICS where METRIC_NAME = 'Average time to process Request by Type';

INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
    to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'Average time to process Request by Type', 5, 'F');

INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
     to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'Average time to process Request by Type', 60, 'F');
	
INSERT INTO AUTOSC.CFG_METRICS (
   METRICS_ID, LAST_ID, LAST_TIME, 
   METRIC_NAME, METRIC_LENGTH, IS_RUNNING) 
VALUES (  CFG_METRICS_SEQ.nextVal, 0, 
     to_date( '2009/02/23 00:00:00', 'YYYY/MM/DD HH24:MI:SS'),
    'Average time to process Request by Type', 1440, 'F');

COMMIT;